Skip to main content

8. Get Sheets productivity tips

In this section:> 8.1 Import data from Forms
8.2 Save time with templates
8.3 Find out if someone changes a spreadsheet
8.4 Add tick boxes to cells

8.1 Import data from Forms​

Analyse data from Google Forms by sending it to Sheets.

  1. In Forms, open the form with the data that you want to import.
  2. At the top, click Responses.
  3. Click Moreand thenSelect response destination.
  4. Create a new spreadsheet or select an existing one.
  5. Click Create or Select.

8.2 Save time with templates​

If you’re creating the same types of files over and over, such as expense reports and purchase orders, save time with a template.

Sheets: Choose an existing template:​

  1. Open Sheets and, at the top, click Template gallery.
  2. Click the template that you want to open it.

Create your own template:​

  1. Open Sheets and, at the top, click Template gallery.
  2. At the top of the gallery, click your organisation’s name.
  3. Click Submit template.
  4. Click Select a spreadsheet, and choose the template file that you created, and then click Open.
  5. Select a category for your file.
  6. Click Submit.

Your new template appears in the template gallery under your organisation’s name.

8.3 Find out if someone changes a spreadsheet​

Notification rules let you know when any changes are made to a spreadsheet.

Sheets: Create notification rules:​

  1. In Sheets, open the spreadsheet where you want to set notifications.
  2. Click Tools and then Notification rules.
  3. Select when and how you want to receive notifications.
  4. Click Save.

8.4 Add tick boxes to cells​

Use tick boxes to make Sheets more interactive. You can use tick boxes with charts, filters, pivot tables and formulas.

Sheets: Add or remove tick boxes:​

  1. In Sheets, open a spreadsheet and select the cells where you want tick boxes.
  2. Click Insertand thenTick box.
  3. (Optional) To delete tick boxes, select the tick boxes that you want to remove and press Delete.

Note: In formulas, unselected tick boxes have a value of FALSE (exclude) and selected tick boxes have a value of TRUE (include). You can see the value in the formula bar. You can also change this value.